Warehouse Management Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
tblWMBOLDetail -- WM Bill of Lading Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BOLDtlRef | int | 4 | |||
BOLRef | int | 4 | |||
Source | tinyint | 1 | 0 | Source | 0 = Manual Entry, 1 = SO Trans |
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
Descr | nvarchar | 35 | |||
Qty | pDecimal | 13 | |||
QtyUOM | pUom | 5 | |||
HandleQty | pDecimal | 13 | 0 | ||
HandleUOM | pUom | 5 | |||
ExtWeight | pDecimal | 13 | 0 | ||
RateClass | nvarchar | 7 | |||
HazMatYn | bit | 1 | 0 | ||
NMFCNo | nvarchar | 10 | |||
CF | xml | -1 |
tblWMBOLDetailCustomerOrder -- WM Bill of Lading Detail Customer Order table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BOLDtlOrderRef | int | 4 | |||
BOLRef | int | 4 | |||
Source | tinyint | 1 | 0 | Source | 0 = Manual Entry, 1 = SO Trans |
CustomerPoNo | nvarchar | 25 | |||
PackQty | pDecimal | 13 | |||
ExtWeight | pDecimal | 13 | |||
PalletSlipYn | bit | 1 | 0 | ||
AddnlShipperInfo | nvarchar | 60 | |||
CF | xml | -1 |
tblWMBOLDetailHM -- WM Bill of Lading Detail Hazardous Material table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BOLHMRef | int | 4 | |||
BOLDtlRef | int | 4 | |||
HMCode | nvarchar | 6 | |||
Descr | nvarchar | 300 | |||
CF | xml | -1 |
tblWMBOLHeader -- WM Bill of Lading Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BOLRef | int | 4 | |||
BOLNum | nvarchar | 17 | |||
ShipDate | datetime | 8 | getdate() | ||
ShipFromId | pLocID | 10 | |||
ShipFromName | nvarchar | 35 | |||
ShipFromAddr1 | nvarchar | 30 | |||
ShipFromAddr2 | nvarchar | 60 | |||
ShipFromCity | nvarchar | 30 | |||
ShipFromRegion | nvarchar | 10 | |||
ShipFromCountry | pCountry | 6 | |||
ShipFromPostalCode | nvarchar | 10 | |||
ShipFromFOBYn | bit | 1 | 0 | ||
SIDNumber | pInvoiceNum | 15 | |||
ShipToId | pCustID | 10 | |||
ShipToName | nvarchar | 30 | |||
ShipToAddr1 | nvarchar | 30 | |||
ShipToAddr2 | nvarchar | 60 | |||
ShipToCity | nvarchar | 30 | |||
ShipToRegion | nvarchar | 10 | |||
ShipToCountry | pCountry | 6 | |||
ShipToPostalCode | nvarchar | 10 | |||
ShipToFOBYn | bit | 1 | 0 | ||
ShipToLocNo | nvarchar | 10 | |||
CIDNumber | pInvoiceNum | 15 | |||
BillToId | pCustID | 10 | |||
BillToName | nvarchar | 30 | |||
BillToAddr1 | nvarchar | 30 | |||
BillToAddr2 | nvarchar | 60 | |||
BillToCity | nvarchar | 30 | |||
BillToRegion | nvarchar | 10 | |||
BillToCountry | pCountry | 6 | |||
BillToPostalCode | nvarchar | 10 | |||
CarrierName | nvarchar | 30 | |||
CarrierSCAC | nvarchar | 4 | |||
CarrierPRO | nvarchar | 20 | |||
VehicleNumber | nvarchar | 16 | |||
SealNumber | nvarchar | 16 | |||
CODFeeType | tinyint | 1 | 0 | COD Fee Type | 0 = Collect, 1 = Prepaid |
CODAmount | pDecimal | 13 | 0 | ||
FreightFeeType | tinyint | 1 | 0 | Freight Fee Type | 0 = Prepaid, 1 = Collect, 2 = 3rd Party |
EmergencyPhone | nvarchar | 20 | |||
EmergencyEXT | nvarchar | 6 | |||
DeclaredValue | pDecimal | 13 | 0 | ||
DeclaredValueUnit | nvarchar | 8 | |||
CustId | pCustID | 10 | |||
SpecialInst | varchar | max | |||
CF | xml | -1 |
*tblWMCycleCount -- WM Cycle Count table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
LocID | pLoc | 2 | |||
CountType | tinyint | 1 | 0 | 0 = ABC Class, 1 = Bin, 2 = Random Bin | |
CountPerYear | int | 0 | |||
CountDaysPerYear | int | 0 | |||
MaxNumOfItems | int | 0 | |||
ItemsWithNoHistYn | bit | 1 | 0 | ||
FreezeYn | bit | 1 | 0 | ||
Filter | nvarchar | max | |||
DisplayFilter | nvarchar | max | |||
ts | timestamp | 8 | |||
CF | xml | -1 |
*tblWMCycleCountActivity -- WM Cycle Count Activity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
LocID | pLoc | 2 | |||
CountType | tinyint | 1 | 0 | 0 = ABC Class, 1 = Bin, 2 = Random Bin | |
NumOfItems | int | 0 | |||
NumOfItemsCounted | int | 0 | |||
Filter | nvarchar | max | |||
DisplayFilter | nvarchar | max | |||
BatchID | pBatchID | ||||
BatchDescr | nvarchar | 50 | |||
CountDate | datetime | 8 | |||
AssignedTo | pEmpID | ||||
PreparedDateTime | datetime | 8 | |||
PreparedBy | pUserID | ||||
FrozenDateTime | datetime | 8 | |||
FrozenBy | pUserID | ||||
PostRun | pPostRun | ||||
ts | timestamp | 8 | |||
CF | xml | -1 |
tblWMExtLoc -- WM Extended Location table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Descr | varchar | 25 | |||
ExtLocID | varchar | 10 | |||
Id | int | 4 | |||
LocID | pLocID | 10 | |||
ts | timestamp | 8 | |||
Type | smallint | 2 | Type | 0 = Bin(A), 1 = Container(B) | |
CF | xml | -1 | |||
*ZoneID | nvarchar | 10 | |||
*ExtLocTypeID | tinyint | 2 | 0 |
*tblWMExtLocType -- WM Extended Location Type table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | tinyint | 2 | |||
Description | pDescription | 25 | |||
AvailableYN | bit | 1 | |||
ts | timestamp | 8 | |||
CF | xml | -1 | |||
*ExtLocARef | integer |
tblWMHistDetail -- WM Detail History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ExtHistSeqNum | int | 4 | |||
HistSeqNum | int | 4 | |||
HistSeqNumSer | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
Lotnum | pLotNum | 16 | |||
Sernum | pSerNum | 35 | |||
ExtLocA | int | 4 | |||
ExtLocAID | nvarchar | 10 | |||
ExtLocB | int | 4 | |||
ExtLocBID | nvarchar | 10 | |||
Source | tinyint | 2 | |||
-*TransId | pTransID | 8 | |||
*TransId | nvarchar | 255 | |||
EntryNum | int | 4 | |||
ReferenceId | pInvoiceNum | 15 | |||
EntryDate | datetime | 8 | getdate() | ||
TransDate | datetime | 8 | |||
Qty | pDecimal | 13 | |||
DeletedYn | bit | 1 | |||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
CF | xml | -1 | |||
*DeleteDate | datetime | 8 | |||
*ZoneID | nvarchar | 10 | |||
*QtyBase | pDecimal | 13 | |||
*Unit | nvarchar | 5 | |||
*UnitBase | nvarchar | 5 | |||
*BOLNum | nvarchar | 255 | |||
*Notes | nvarchar | max | |||
*ActivityType | bit | 1 | 0 = Move, 1 = Receive, 2 = Putaway, 3 = Pick, 4 = Ship, 5 = Adjust |
*tblWMHistPhysicalCountDetail -- WM Physical Count History Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | ||||
CountDetailID | bigint | ||||
HeaderID | bigint | ||||
BatchID | pBatchID | ||||
ExtLocA | int | 4 | |||
ExtLocAID | nvarchar | 10 | |||
ExtLocB | int | 4 | |||
ExtLocBID | nvarchar | 10 | |||
LotNum | pLotNum | ||||
SerNum | pSerNum | ||||
QtyFrozen | pDecimal | 13 | |||
QtyCounted | pDecimal | 13 | |||
TagNum | nvarchar | 10 | |||
NewExtLocAID | nvarchar | 10 | |||
NewExtLocBID | nvarchar | 10 | |||
QtyStatus | smallint | ||||
CF | xml | -1 |
*tblWMHistPhysicalCountEntry -- WM Physical Count Entry History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | ||||
CountEntryID | bigint | ||||
BatchID | pBatchID | ||||
DetailID | bigint | ||||
ItemID | pItemID | ||||
LocID | pLocID | 10 | |||
LotNum | pLotNum | ||||
SerNum | pSerNum | ||||
ExtLocA | int | 4 | |||
ExtLocAID | nvarchar | 10 | |||
ExtLocB | int | 4 | |||
ExtLocBID | nvarchar | 10 | |||
QtyCounted | pDecimal | 13 | |||
CountUom | pUom | ||||
TagNum | nvarchar | 10 | |||
Status | tinyint | ||||
EntryDate | datetime | 8 | |||
UID | pUserID | ||||
HostID | pWrkStnID | ||||
ErrorFlag | tinyint | ||||
CF | xml | -1 |
*tblWMHistPhysicalCountHeader -- WM Physical Count History Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | ||||
ID | bigint | ||||
BatchID | pBatchID | ||||
ItemID | pItemID | ||||
LocID | pLocID | 10 | |||
CountUom | pUom | ||||
CountUomConvFactor | pDecimal | 13 | |||
ABCClass | nvarchar | 10 | |||
CF | xml | -1 |
*tblWMLocationZone -- WM Location Zone table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | 8 | |||
LocID | pLocID | 10 | |||
ZoneID | nvarchar | 10 | |||
Description | pDescription | 25 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMMatReq -- WM Material Requirements table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TranKey | int | 4 | |||
ReqType | smallint | 2 | -1 | ||
ReqNum | nvarchar | 10 | |||
DatePlaced | datetime | 8 | getdate() | ||
DateNeeded | datetime | 8 | getdate() | ||
LocID | pLocID | 10 | |||
ShipToId | pCustID | 10 | |||
ShipVia | nvarchar | 20 | |||
ReqstdBy | nvarchar | 25 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
Notes | varchar | max | |||
Status | tinyint | 1 | Status | 0 = Open, 1 = Completed |
tblWMMatReqFilled -- WM Material Requirements Filled table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TranKey | int | 4 | |||
LineNum | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
SerNum | pSerNum | 35 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
Qty | pDecimal | 13 | 0 | ||
UOM | pUom | 5 | |||
UnitCost | pDecimal | 13 | 0 | ||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
GlPeriod | smallint | 2 | |||
GlYear | smallint | 2 | |||
QtySeqNum | int | 4 | |||
QtySeqNum_Ext | int | 4 | |||
HistSeqNum | int | 4 | |||
HistSeqNumSer | int | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
Status | tinyint | 1 | Status | 0 = Unposted, 1 = Posted | |
*UnitCostACV | pDecimal | 13 |
tblWMMatReqRequest -- WM Material Requirements Request table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TranKey | int | 4 | |||
LineNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
Qty | pDecimal | 13 | 0 | ||
QtyFilled | pDecimal | 13 | 0 | ||
UOM | pUom | 5 | |||
UnitCost | pDecimal | 13 | 0 | ||
GLAcctNum | pGlAcct | 255 | |||
GLDescr | pGLDesc | 30 | |||
QtySeqNum | int | 4 | |||
QtySeqNum_Ext | int | 4 | |||
LineSeq | int | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMMoveQtyDetail -- WM Move Quantity Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | int | 4 | |||
HeaderId | int | 4 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
Qty | pDecimal | 13 | 0 | ||
QtyMoved | pDecimal | 13 | 0 | ||
EntryDate | datetime | 8 | getdate() | ||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMMoveQtyHeader -- WM Move Quantity Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | int | 4 | |||
MoveStatus | tinyint | 0 | 0 = Moving From, 1 = Moving To | ||
MoveBy | tinyint | 1 | 0 | Move By | 0 = Item, 1 = Container |
MoveById | pItemID | 24 | |||
LocID | pLocID | 10 | |||
ExtLocAFrom | int | 4 | |||
ExtLocBFrom | int | 4 | |||
ExtLocATo | int | 4 | |||
ExtLocBTo | int | 4 | |||
Qty | pDecimal | 13 | 0 | ||
QtyMoved | pDecimal | 13 | 0 | ||
UOM | pUom | 5 | |||
EntryDate | datetime | 8 | getdate() | ||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMMoveQuantity -- WM Move Quantity table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
EntryDate | datetime | 8 | getdate() | ||
ExtLocAFrom | int | 4 | |||
ExtLocATo | int | 4 | |||
ExtLocBFrom | int | 4 | |||
ExtLocBTo | int | 4 | |||
HostId | pWrkStnID | 20 | |||
Id | int | 4 | |||
LocID | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
MoveBy | tinyint | 1 | Move By | 0 = ItemId, 1 = ExtLocB | |
MoveById | pItemID | 24 | |||
ParentId | int | 4 | |||
Qty | pDecimal | 13 | |||
SerNum | pSerNum | 35 | |||
TransDate | datetime | 8 | getdate() | ||
ts | timestamp | 8 | |||
UID | pUserID | 20 | |||
UOM | pUom | 5 | |||
*FunctionID | |||||
CF | xml | -1 | |||
*PutawayReqID | bigint |
tblWmPhysCountAWMS -- WM Physical Count for AWMS (Advanced Warehouse Management) table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | int | 4 | |||
SeqNum | int | 4 | |||
DtlSeqNum | int | 4 | |||
BatchId | pBatchID | 6 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
QtyCounted | pDecimal | 13 | 0 | ||
CountedUom | pUom | 5 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
ExtLocAId | nvarchar | 10 | |||
ExtLocBId | nvarchar | 10 | |||
EntryDate | datetime | 8 | getdate() | ||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblWmPhysicalCountBatch -- WM Physical Count Batch table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BatchId | pBatchID | 6 | |||
Description | pDescription | 35 | |||
CountDate | datetime | 8 | getdate() | ||
AssignedTo | pEmpID | 20 | |||
PreparedDateTime | datetime | 8 | |||
PreparedBy | pUserID | 20 | |||
FrozenDateTime | datetime | 8 | |||
FrozenBy | pUserID | 20 | |||
LocId | pLocID | 10 | |||
Filter | nvarchar | max | |||
DisplayFilter | nvarchar | max | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblWmPhysicalCountBinList -- WM Physical Count Bin List table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | 8 | |||
BatchId | pBatchID | 6 | |||
LocId | pLocID | 10 | |||
ExtLocAId | nvarchar | 10 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblWmPhysicalCountCostVariance -- WM Physical Count Cost Variance table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | 8 | |||
BatchId | pBatchID | 6 | |||
ItemId | pItemID | 24 | |||
LotNum | pLotNum | 16 | |||
CostVariance | pDecimal | 13 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblWmPhysicalCountDetail -- WM Physical Count Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
HeaderId | bigint | 8 | |||
BatchId | pBatchID | 6 | |||
ExtLocAId | nvarchar | 10 | |||
ExtLocBId | nvarchar | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
QtyFrozen | pDecimal | 13 | |||
QtyCounted | pDecimal | 13 | |||
TagNum | int | 4 | |||
NewExtLocAId | nvarchar | 10 | |||
NewExtLocBId | nvarchar | 10 | |||
QtyStatus | smallint | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblWmPhysicalCountEntry -- WM Physical Count Entry table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 8 | |||
BatchId | pBatchID | 6 | |||
DetailId | bigint | 8 | |||
ItemId | pItemID | 24 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
ExtLocAId | nvarchar | 10 | |||
ExtLocBId | nvarchar | 10 | |||
QtyCounted | pDecimal | 13 | |||
CountUom | pUom | 5 | |||
TagNum | int | 4 | |||
Status | tinyint | 1 | 0 = New; 1 = Verified; 2 = CountChanged; 3 = Deleted | ||
EntryDate | datetime | 8 | |||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
ErrorFlag | tinyint | 1 | 0 | 0 = No Error | |
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblWmPhysicalCountHeader -- WM Physical Count Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | 8 | |||
BatchId | pBatchID | 6 | |||
ItemId | pItemID | 24 | |||
CountUom | pUom | 5 | |||
CountUomConvFactor | pDecimal | 13 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMPick -- WM Pick table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PickKey | int | 4 | |||
SourceId | tinyint | 1 | Source Type | 0 = Sales Order, 1 = Production Order, 2 = Work Order, 4 = WM Transfer, 8 = WM Material Requisition, 32 = PC Material Requisition | |
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
SeqNum | int | 4 | |||
PickNum | pInvoiceNum | 15 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
SerNum | pSerNum | 35 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
UOM | pUom | 5 | |||
QtyPicked | pDecimal | 13 | 0 | ||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
GrpId | int | 4 | |||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
HistSeqNum | int | 4 | |||
HistSeqNumSer | int | 4 | |||
QtySeqNum | int | 4 | |||
QtySeqNumExt | int | 4 | |||
Status | tinyint | 1 | Status | 0 = New, 1 = Confirmed, 2 = Completed | |
*Type | tinyint | 1 | 0 = Pick, 1 = Move, 2 = Pack | ||
*ExtLocATo | int | 4 | |||
*ExtLocBTo | int | 4 | |||
*PackNumber | pInvoiceNum | 15 |
tblWMPick_Gen -- WM Pick Generation table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PickGenKey | int | 4 | |||
SourceId | tinyint | 1 | Source Type | 0 = Sales Order, 1 = Production Order, 2 = Work Order, 4 = WM Transfer, 8 = WM Material Requisition, 32 = PC Material Requisition | |
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
SeqNum | int | 4 | |||
PickNum | pInvoiceNum | 15 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
UOM | pUom | 5 | |||
QtyReq | pDecimal | 13 | 0 | ||
ReqDate | datetime | 8 | |||
Ref1 | pTransID | 8 | |||
Ref2 | pTransID | 8 | |||
Ref3 | pTransID | 8 | |||
GrpId | int | 4 | |||
OriCompQty | pDecimal | 13 | 0 | ||
PickID | nvarchar | 20 | |||
KitID | pItemID | 24 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMPickInfo -- WM Pick Information table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Description | varchar | 50 | |||
-*DisplayFilter | nvarchar | max | |||
-*Filter | nvarchar | max | |||
Id | varchar | 20 | |||
-*Selected | int | 4 | |||
ts | timestamp | 8 | |||
CF | xml | -1 | |||
*PickDate | datetime | 8 | |||
*AssignedTo | pEmpID | 20 | |||
*EntryDate | datetime | 8 | |||
*LocID | pLocID | 10 |
tblWMPutawayDetail -- WM Putaway Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | 20 | |||
ParentId | int | 4 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
Qty | pDecimal | 13 | |||
UOM | pUom | 5 | |||
EntryDate | datetime | 8 | |||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMPutawayHeader -- WM Putaway Header table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | 20 | |||
LocID | pLocID | 10 | |||
ItemID | pItemID | 24 | |||
ExtLocAFrom | int | 4 | |||
ExtLocBFrom | int | 4 | |||
ExtLocATo | int | 4 | |||
ExtLocBTo | int | 4 | |||
Qty | pDecimal | 13 | |||
UOM | pUom | 5 | |||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
*tblWMPutawayRequest -- WM Putaway Request table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | 20 | |||
ParentID | bigint | ||||
TransKey | int | ||||
TransType | tinyint | 1 | 0 = Receipt, 1 = Pick (for cancel orders) | ||
TransId | nvarchar | 20 | |||
EntryNum | bigint | ||||
ItemID | pItemID | 24 | |||
LocID | pLocID | 10 | |||
LotNum | pLotNum | ||||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
UOM | pUom | 5 | |||
SerNum | pSerNum | ||||
Source | tinyint | 0 = PO, 1 = WM Transfer Rcpt, 2 = MP Production Rcpt, 3 = WM Mat Req Ret, 4 = SO RMA, 5 = PC Mat Req Ret, 6 = SD Part Ret, 7 = SR Rcpt, 8 = SO, 9 = MP Production, 10 = SD, 11 = WM Transfer, 12 = WM Mat Req, 13 = PC Mat Req, 14 = PO Ret, 15 = SR | |||
QtyReq | pDecimal | 13 | |||
QtyFilled | pDecimal | 13 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMRcpt -- WM Receipt table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
RcptKey | int | 4 | |||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | |||
ReceiptNum | pInvoiceNum | 15 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
SerNum | pSerNum | 35 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
UOM | pUom | 5 | |||
Qty | pDecimal | 13 | 0 | ||
Source | tinyint | 1 | 0 | Source | 0 = PO, 1 = Transfer, 2 = MP Production, 8 = WM Material Requisition Return, 16 = SO RMA, 32 = PC Material Requisition Return |
ErrorFlag | tinyint | 1 | 0 | ||
UID | pUserID | 20 | |||
HostId | pWrkStnID | 20 | |||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
HistSeqNum | int | 4 | |||
HistSeqNumSer | int | 4 | |||
QtySeqNum | int | 4 | |||
QtySeqNumExt | int | 4 | |||
Status | tinyint | 1 | Status | 0 = New, 1 = Confirmed, 2 = Completed, 3=Put Away | |
*BOLNum | nvarchar | 255 | |||
*Notes | nvarchar | max |
tblWMTrans -- WM Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
BatchId | pBatchID | 6 | '######' | ||
TransType | tinyint | 1 | Transaction Type | 31 = Increase, 32 = Decrease | |
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
Qty | pDecimal | 13 | 0 | ||
Uom | pUom | 5 | |||
UnitCost | pDecimal | 13 | 0 | ||
EntryDate | datetime | 8 | getdate() | ||
TransDate | datetime | 8 | getdate() | ||
GLPeriod | smallint | 2 | |||
GlYear | smallint | 2 | |||
GLAcctOffset | pGlAcct | 255 | |||
HistSeqNum | int | 4 | |||
QtySeqNum | int | 4 | |||
QtySeqNumExt | int | 4 | |||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMTransfer -- WM Transfer table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TranKey | int | 4 | |||
BatchID | pBatchID | 6 | |||
Status | tinyint | 1 | 0 | Status | 0 = New, 1 = Picked, 2 = Completed |
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LocIdTo | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
Qty | pDecimal | 13 | 0 | ||
UOM | pUom | 5 | |||
CostTransfer | pDecimal | 13 | 0 | ||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
PackNum | pTransID | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
Cmnt | varchar | max | |||
-*QtySeqNum_OnOrd | int | 4 | |||
-*QtySeqNum_Cmtd | int | 4 | |||
*QuickTransferYn | bit | 1 | 0 |
tblWMTransferPick -- WM Transfer Pick table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TranKey | int | 4 | |||
TranPickKey | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
SerNum | pSerNum | 35 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
Qty | pDecimal | 13 | 0 | ||
UOM | pUom | 5 | |||
UnitCost | pDecimal | 13 | 0 | ||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
GlPeriod | smallint | 2 | |||
GlYear | smallint | 2 | |||
QOHSeqNum | int | 4 | |||
QOHSeqNumExt | int | 4 | |||
QOOSeqNum | int | 4 | |||
HistSeqNum | int | 4 | |||
HistSeqNumSer | int | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
Status | tinyint | 1 | Status | 0 = Unposted, 1 = Posted | |
*UnitCostACV | pDecimal | 13 |
tblWMTransferRcpt -- WM Transfer Receipt table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TranPickKey | int | 4 | |||
TranRcptKey | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
SerNum | pSerNum | 35 | |||
LotNum | pLotNum | 16 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
Qty | pDecimal | 13 | 0 | ||
UOM | pUom | 5 | |||
UnitCost | pDecimal | 13 | 0 | ||
EntryDate | datetime | 8 | |||
TransDate | datetime | 8 | |||
GlPeriod | smallint | 2 | |||
GlYear | smallint | 2 | |||
QOHSeqNum | int | 4 | |||
QOHSeqNumExt | int | 4 | |||
HistSeqNum | int | 4 | |||
HistSeqNumSer | int | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
Status | tinyint | 1 | Status | 0 = Unposted, 1 = Posted | |
*UnitCostACV | pDecimal | 13 |
tblWMTransSer -- WM Serial Number Transaction table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | int | 4 | |||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
CostUnit | pDecimal | 13 | 0 | ||
CostUnitFgn | pDecimal | 13 | 0 | ||
PriceUnit | pDecimal | 13 | 0 | ||
PriceUnitFgn | pDecimal | 13 | 0 | ||
HistSeqNum | int | 4 | |||
Cmnt | nvarchar | 35 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*CostUnitACV | pDecimal | 13 |
tblWMUser -- WM User table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | ||||
EmployeeID | pEmpID | ||||
Password | nvarchar | max | |||
ScheduleID | nvarchar | 10 | |||
LocID | pLocID | ||||
BatchId | pBatchID | ||||
ExtLocA | int | 4 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMUserPermission -- WM User Permission table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Id | bigint | ||||
UserID | bigint | 20 | |||
FeatureID | bigint | ||||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblWMUserTaskCode -- WM User Task Code table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
ID | bigint | ||||
UserID | bigint | ||||
TaskCode | nvarchar | 10 | |||
SkillLevel | tinyint | ||||
CF | xml | -1 | |||
ts | timestamp | 8 |